Today's Question:  What does your personal desk look like?        GIVE A SHOUT

SEARCH KEYWORD -- Remove redundancy

  How does MySQL handle DROP TABLE

A few days ago, when executing DROP TABLE in MySQL, all processes including DDL and DML were hung until DROP TABLE was completed. I am confused about this phenomenon. I have reviewed the source codes of MySQL to check how MySQL internally handle DROP TABLE. When user trigger DROP TABLE command: ########################MySQL SERVER drop table######################## /* Sql_table.cc  delete (drop) tables. */bool mysql_rm_table( )   /*   Execute the drop of a normal or temporary...

   MySQL,DROP TABLE     2012-09-24 11:34:05

  Waking up early, 10 tips that work

In this blog post I am going to cover a topic that I have been occupied with for several weeks now: Becoming an early riser. Getting up early can be a great way to help you establish a daily routine which is the first step to becoming more productive. Here I present you 10 tips that helped me in becoming an early riser. 1. Get up The most important step is to get up. Actually not just get up, literally try to jump out of bed. After your alarm rings get up instantly, go to another room and t...

   Body,Rest,Health     2012-04-11 13:44:34

  Guide to Clearing Storage Space on a Macbook

Macbooks are pretty notorious when it comes to what storage space you have available. Those few gigabytes that you have will disappear in no time if you are not careful. The whole issue becomes even more problematic for people who are not that familiar with Macbooks or have switched from another computer. And if you do not pay attention, it will not take too long before you have next to no storage space on the hard drive. Leaving only a few gigabytes of free space will significantly reduce the ...

   MACBOOK,APPLE,DATA STORAGE     2020-08-08 00:21:42

  Frequently used Git commands

Git configuration git config --global user.name "robbin" git config --global user.email "fankai@gmail.com" git config --global color.ui true git config --global alias.co checkout git config --global alias.ci commit git config --global alias.st status git config --global alias.br branch git config --global core.editor "mate -w" # Configure Editor to use textmate git config -l #List all configurations User's git configuration file : ~/.gitconfig Frequently used Git commands Check、add...

   Git,Command     2013-03-11 19:41:06

  JavaScript delete specific item from array

Deleting an item from an array is easy using JavaScript’s built-in method splice(). However, if you are somewhat new to scripting, simply knowing about splice does not help you remove a certain item from an array. This article will solidly state the solution to this dilemma.If you want to remove a specific item from your array, you will simply use a basic loop and a conditional check with the splice()method.Here is a breakdown of what we will do in 3 easy steps, so tha...

   JavaScript,Array,Remove item,Splice,Dele     2011-09-16 16:38:52

  SQL Server: Removing Deprecated Code and Future Proofing your Queries

New features are added with every release of SQL Server and as a result, some features get removed or deprecated. Deprecated features are features that are still operational (for backward compatibility) but will be removed in a future version. Deprecated features can be of two types: those that will be deprecated in a future version and those that will be deprecated in the next version.In this article, we will explore how to track deprecated code and correct it. I will also share our observation...

   SQL Server,Microsoft,MS SOL,Proof query,Remove redundancy     2011-10-17 11:14:49

  Advanced event registration models

On this page I explain the two advanced event registration models: W3C’s and Microsoft’s. Since neither is cross–browser supported, their use is, for the moment, deprecated. W3C and Microsoft have both developed their own event registration model to replace Netscape’s traditional model. Though I’m not impressed by the Microsoft model, W3C’s is very good, except for one crucial vagueness. Unfortunately few browsers support it at the moment. W3C W3Câ...

   JavaScript,Event model,this,bubble,capturing     2011-12-27 09:20:44

  11 Important Database designing rules

Introduction Before you start reading this article let me confirm that I am not a guru in database designing. The below 11 points which are listed are points which I have learnt via projects, my own experiences and my own reading. I personally think it has helped me a lot when it comes to DB designing. Any criticism welcome. The reason why I am writing a full blown article is, when developers sit for designing a database they tend to follow the three normal forms like a silver bullet. They...

   Database design,Rules,OLAP     2012-04-12 05:51:38

  Good ways to "insult" a computer scientist

Computer scientists are a group of people who are hard working and talented. They build the theory foundation for information and computation and they usually work on something difficult to understand. Many computer algorithms are created by computer scientists. In our mind, they are those people we admire most. But sometimes we also want to make fun of them or "insult" them. What are good ways to "insult" them? Here we share some. Ask him to make a website for you...and with PHP. Ask them why ...

   Computer scientist,Jokes     2013-08-06 09:32:56

  Can API be copyrighted? At least Oracle hopes so

  The result of the lawsuit case war between Oracle and Google is clearer now. The court said that 9 lines of code of Android has violated intellectual property right, these 9 lines of code can be ignored relative to the number of codes for the whole Android system. But just like LinuxToy points out that the reasons why this case catches so much attention are : 1). The amount of money Oracle asked from Google is $1 billion; 2). The statement says Java language itself doesn't violate the int...

   Oracle,Google,API,Copyright,Lawsuit case     2012-05-11 00:47:58

RECENT